CREATE VIEW [dbo].[vProduct]
AS
SELECT p.DEFERRED_INCOME_ACCOUNT AS DeferredIncomeAccount, p.DESCRIPTION AS Description, p.INCOME_ACCOUNT AS IncomeAccount,
       p.PRICE_1 AS Price1, p.PRICE_2 AS Price2, p.PRICE_3 AS Price3, p.PROD_TYPE AS ProductType, p.PRODUCT_CODE AS ProductCode,
       p.PRODUCT_MAJOR AS ProductMajor, p.PRODUCT_MINOR AS ProductMinor, p.STATUS AS Status, p.TITLE AS Title,
       p.TITLE_KEY AS TitleKey, p.CATEGORY AS ProductCategory, p.APPLY_IMAGE, p.APPLY_THUMBNAIL, p.IMAGE_URL, p.THUMBNAIL_URL,
       p.WEB_DESC, p.WEB_OPTION, op.IsSuperProduct, op.SellOnWeb, opcl.IsFeatured
   FROM Product p
        LEFT OUTER JOIN OrderProduct op ON p.PRODUCT_CODE = op.ProductCode
        LEFT OUTER JOIN OrderProductCategoryLookup opcl ON op.OrderProductID = opcl.OrderProductID


GO